2016-01-12 - 28509 - Spec - NA Retail data source #RetailPro
SPECIFICATIONS
28509 - NA Retail data source
Purpose
Need to create new BI data source for North American Retail.
Admin Info
Purpose
|
Need to create new BI data source for North American Retail.
|
Requested By
|
Autumn Joyce
|
Spec Created By
|
Uday Kumar P
|
Spec Created Date
|
12/01/2016
|
Spec QA by
|
Uday Kumar P
|
Objects
|
North America Sales and ShopperTrak Source.
|
Document Status
|
Complete
|
Estimates
SNo
|
Activity
|
Estimation in Hours
|
1
|
Research
|
08
|
2
|
Documentation
|
02
|
3
|
Development/ Config
|
40
|
4
|
Unit test in DEV
|
20
|
5
|
Unit test in QUA
|
00
|
6
|
Other activity
|
00
|
|
TOTAL
|
70
|
References
Prior Tickets
None
Documents
None
Spec Changes
SNo
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1
|
Develop ShopperTrak data source
|
Mark Harris
|
12/05/2016
|
Email
|
2
|
Automate Retail Data Loads & ShopperTrak data loads
|
Mark Harris
|
03/02/2017
|
Email
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
Need to develop new North America Retail Source.
In Scope:
North America Point Of Sale & ShopperTrak Source.
Out of Scope:
Other Retail sources.
Solution Summary
1. Need to design and develop new North America Retail source for Point Of Sale and ShopperTrak source.
2. Need to develop SQL views for master data and Transactional data sources in NA SQL DB.
3. Need to replicate the corresponding views into BW and generate data sources using them.
4. Need to create DSO Object for Point of Sale & ShopperTrak sources.
5. Need to point DSOs to Infocubes and generate Multiprovider on top of them.
6. Need to create BEx Queries on the Multiprovider.
Solution Details
A) For Master Data Objects:
1. Created Oracle DB Views for master data as follows:
RP_PRD_PRICE_V - Pricing to fetch Cost and MSRP at material level.
RP_PRD_MAT_INV_SEA_COL - To fetch season & collection for material based on Subsidiary & Store.
RP_PRD_MAT_RECEIVED_DATES - To fetch last date & first received for material based on customer.
RP_PRD_MAT_SOLD_DATE - To fetch last date sold for material based on customer.
2. Need to generate data sources for the above views and point to corresponding targets.
RP_PRD_PRICE_V - ZNA_RPRCN
RP_PRD_MAT_INV_SEA_COL - ZNA_MATDT
RP_PRD_MAT_RECEIVED_DATES - ZNA_MATDT
RP_PRD_MAT_SOLD_DATE - ZNA_MATDT
3. Create new info objects
ZNA_RPRCN - Pricing
ZNA_MATDT - Material Master
4. Assign Customer in BW based on Subsidiary & Store.
5. Need to create corresponding info packages, develop transformations & DTP'S.
B) For Transaction Data Objects:
1. Need to create Oracle DB view for point of sale and replicate to BW.
RP_PRD_POS_DELTA_V - 6DB_RP_PRD_POS_DELTA_V.
2. Need to create DSO ZNA_OSHT on data source 6DB_RP_PRD_POS_DELTA_V.
3. Need to develop customer based subsidiary & store:
0001020694(US - NEW ERA NEW ORLEANS RETAIL STORE) = Subsidiary 1 + Store 5
0001020730(US - NEW ERA NEW YORK CITY RETAIL STORE) = Subsidiary 1 + Store 6
0001020731(US - NEW ERA BUFFALO RETAIL STORE) = Subsidiary 1 + Store 8
0001020732(CA - NEW ERA TORONTO RETAIL STORE) = Subsidiary 2 + Store 1
4. Need to point DSO data to infocube ZNA_RPC01 and load the data.
5. Need to create new data source for ShopperTrak source.
6. As the source system is flat file, need to design the data source according to flat file.
7. Need to create new DSO for ShopperTrak source and calculate traffic based on entry and exit and based on daily totals.
8. Based on File data need to assign customer:
BUFF1(Buffalo) – 0001020731(US - NEW ERA BUFFALO RETAIL STORE).
NOR1(New Orleans) – 0001020694(US - NEW ERA NEW ORLEANS RETAIL STORE).
NYC1(New York) – 0001020730(US - NEW ERA NEW YORK CITY RETAIL STORE).
TOR1(Toronto) – 0001020732(CA - NEW ERA TORONTO RETAIL STORE).
9. Need to point the DSO data to infocube ZNA_CSHT and load the data from DSO to infocube.
10. Need to merge Point Of Sale & ShopperTrak source in Multiprovider(ZNA_RPM01).
C) Automation Of Data Loads:
1. Need to create a new info package to pick a file from application server daily where the file name changes with system date.
2. Need to create a new process chain to automate the data loads for NA Retail Source.
3. Need to create a new transport request and collect all the necessary changes into it.
D) BEx Queries: Need to create multiple BEx Queries for reporting as follows:
1. Need to create Analysis Report for North America Retail with all possible measures.
2. Need to create multiple BEx Query for Retail Pro Sales By Store, Season, Collection, Silhouette and Calendar Week.
3. Need to create BEx Query for Weekly Sales & Conversion Analysis.
E) Need to collect all the objects into transport request and move them to Production as Quality system is not available due to BW HANA upgrade.
Issues
None